/*
 Navicat Premium Data Transfer

 Source Server         : mysql_copy
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : localhost
 Source Database       : vote_system

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : utf-8

 Date: 11/09/2020 17:34:46 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `votes`
-- ----------------------------
DROP TABLE IF EXISTS `votes`;
CREATE TABLE `votes` (
  `vote_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `yb_userid` bigint(20) NOT NULL,
  `vote_time` datetime NOT NULL,
  `table_id` bigint(20) NOT NULL,
  `data` text NOT NULL,
  `yb_classname` varchar(100) DEFAULT NULL,
  `yb_collegename` varchar(100) DEFAULT NULL,
  `yb_employid` bigint(20) DEFAULT NULL,
  `yb_realname` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`vote_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `votes`
-- ----------------------------
BEGIN;
INSERT INTO `votes` VALUES ('2', '18884862', '2020-11-09 15:48:13', '1', '{\"question1\":\"浙江温州\",\"question2\":[\"item2\",\"item3\"],\"question3\":\"item2\"}', '计科18C', '理工分院', null, '洪德衍');
COMMIT;

-- ----------------------------
--  Table structure for `vtable`
-- ----------------------------
DROP TABLE IF EXISTS `vtable`;
CREATE TABLE `vtable` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `cdate` datetime NOT NULL COMMENT '创建时间',
  `edate` datetime NOT NULL COMMENT '结束时间',
  `context` text COMMENT '对于投票的描述',
  `sdate` datetime DEFAULT NULL COMMENT '开始时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `vtable`
-- ----------------------------
BEGIN;
INSERT INTO `vtable` VALUES ('1', '这是测试内容', '2020-11-09 14:47:28', '2020-10-27 14:47:30', '{\"pages\":[{\"name\":\"page1\",\"elements\":[{\"type\":\"text\",\"name\":\"question1\"}]},{\"name\":\"page2\",\"elements\":[{\"type\":\"checkbox\",\"name\":\"question2\",\"choices\":[\"item1\",\"item2\",\"item3\"]}]},{\"name\":\"page3\",\"elements\":[{\"type\":\"radiogroup\",\"name\":\"question3\",\"choices\":[\"item1\",\"item2\",\"item3\"]}]}]}', '2020-11-09 17:06:20');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
